home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
95.86.62.111
/
95.86.62.111.tar
/
95.86.62.111
/
Skripti
/
SoartPolni zaboraveno.sql
< prev
next >
Wrap
Text File
|
2011-10-22
|
441b
|
8 lines
Insert Into Soart (Sifra_Oe, Sifra_Art, Vlez, Izlez, Prof_Rez, Cena,
DanCena, POsn, NabCena, DokCena, Uces, VRN_Vlez,
VRN_Izlez, NNabCena, NMinCena, NMaxCena)
Select NOVATA OE, Sifra_Art, 0, 0, Prof_Rez, Cena,
DanCena, POsn, NabCena, DokCena, Uces, VRN_Vlez,
VRN_Izlez, NNabCena, NMinCena, NMaxCena
From soart where sifra_oe = OD_KOJA_OE_ZEMASS
and sifra_art not in (select sifra_art from soart where sifra_oe = NOVATA_OE)